property profile

Dataset statistics

Number of variables	10
Number of observations	21613
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	1.6 MiB
Average record size in memory	80.0 B

Variable types

Numeric	9
Categorical	1

Alerts

`bedrooms` is highly overall correlated with `sqft_living`	High correlation
`floors` is highly overall correlated with `grade` and 1 other fields	High correlation
`grade` is highly overall correlated with `floors` and 3 other fields	High correlation
`price` is highly overall correlated with `grade` and 1 other fields	High correlation
`sqft_living` is highly overall correlated with `bedrooms` and 2 other fields	High correlation
`yr_built` is highly overall correlated with `floors` and 1 other fields	High correlation
`sqft_basement` has 13126 (60.7%) zeros	Zeros

Reproduction

Analysis started	2024-12-09 02:03:24.267475
Analysis finished	2024-12-09 02:03:33.136598
Duration	8.87 seconds
Software version	ydata-profiling vv4.12.0
Download configuration	config.json

date
Real number (ℝ)

Distinct	372
Distinct (%)	1.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	143902.67

Minimum	140502
Maximum	150527
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	169.0 KiB

Quantile statistics

Minimum	140502
5-th percentile	140520
Q1	140722
median	141016
Q3	150217
95-th percentile	150427
Maximum	150527
Range	10025
Interquartile range (IQR)	9495

Descriptive statistics

Standard deviation	4436.5825
Coefficient of variation (CV)	0.030830439
Kurtosis	-1.4249889
Mean	143902.67
Median Absolute Deviation (MAD)	389
Skewness	0.75269642
Sum	3.1101684 × 10⁹
Variance	19683264
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
140623	142	0.7%
140625	131	0.6%
140626	131	0.6%
140708	127	0.6%
150427	126	0.6%
150325	123	0.6%
150428	121	0.6%
150422	121	0.6%
140709	121	0.6%
150414	121	0.6%
Other values (362)	20349	94.2%

Value	Count	Frequency (%)
140502	67	0.3%
140503	4	< 0.1%
140504	5	< 0.1%
140505	84	0.4%
140506	83	0.4%
140507	93	0.4%
140508	81	0.4%
140509	81	0.4%
140510	5	< 0.1%
140511	2	< 0.1%

Value	Count	Frequency (%)
150527	1	< 0.1%
150524	1	< 0.1%
150515	1	< 0.1%
150514	11	0.1%
150513	31	0.1%
150512	49	0.2%
150511	40	0.2%
150510	2	< 0.1%
150509	3	< 0.1%
150508	54	0.2%

floors
Real number (ℝ)

High correlation

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.494309

Minimum	1
Maximum	3.5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	169.0 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1.5
Q3	2
95-th percentile	2
Maximum	3.5
Range	2.5
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.5399889
Coefficient of variation (CV)	0.36136361
Kurtosis	-0.48472294
Mean	1.494309
Median Absolute Deviation (MAD)	0.5
Skewness	0.61617672
Sum	32296.5
Variance	0.29158801
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
1	10680	49.4%
2	8241	38.1%
1.5	1910	8.8%
3	613	2.8%
2.5	161	0.7%
3.5	8	< 0.1%

Value	Count	Frequency (%)
1	10680	49.4%
1.5	1910	8.8%
2	8241	38.1%
2.5	161	0.7%
3	613	2.8%
3.5	8	< 0.1%

Value	Count	Frequency (%)
3.5	8	< 0.1%
3	613	2.8%
2.5	161	0.7%
2	8241	38.1%
1.5	1910	8.8%
1	10680	49.4%

bedrooms
Real number (ℝ)

High correlation

Distinct	13
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.3708416

Minimum	0
Maximum	33
Zeros	13
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	169.0 KiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	3
median	3
Q3	4
95-th percentile	5
Maximum	33
Range	33
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.93006183
Coefficient of variation (CV)	0.27591383
Kurtosis	49.063653
Mean	3.3708416
Median Absolute Deviation (MAD)	1
Skewness	1.9742995
Sum	72854
Variance	0.86501501
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=13)

Value	Count	Frequency (%)
3	9824	45.5%
4	6882	31.8%
2	2760	12.8%
5	1601	7.4%
6	272	1.3%
1	199	0.9%
7	38	0.2%
0	13	0.1%
8	13	0.1%
9	6	< 0.1%
Other values (3)	5	< 0.1%

Value	Count	Frequency (%)
0	13	0.1%
1	199	0.9%
2	2760	12.8%
3	9824	45.5%
4	6882	31.8%
5	1601	7.4%
6	272	1.3%
7	38	0.2%
8	13	0.1%
9	6	< 0.1%

Value	Count	Frequency (%)
33	1	< 0.1%
11	1	< 0.1%
10	3	< 0.1%
9	6	< 0.1%
8	13	0.1%
7	38	0.2%
6	272	1.3%
5	1601	7.4%
4	6882	31.8%
3	9824	45.5%

sqft_living
Real number (ℝ)

High correlation

Distinct	1038
Distinct (%)	4.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2079.8997

Minimum	290
Maximum	13540
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	169.0 KiB

Quantile statistics

Minimum	290
5-th percentile	940
Q1	1427
median	1910
Q3	2550
95-th percentile	3760
Maximum	13540
Range	13250
Interquartile range (IQR)	1123

Descriptive statistics

Standard deviation	918.4409
Coefficient of variation (CV)	0.44157941
Kurtosis	5.243093
Mean	2079.8997
Median Absolute Deviation (MAD)	540
Skewness	1.4715554
Sum	44952873
Variance	843533.68
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1300	138	0.6%
1400	135	0.6%
1440	133	0.6%
1660	129	0.6%
1010	129	0.6%
1800	129	0.6%
1820	128	0.6%
1480	125	0.6%
1720	125	0.6%
1560	124	0.6%
Other values (1028)	20318	94.0%

Value	Count	Frequency (%)
290	1	< 0.1%
370	1	< 0.1%
380	1	< 0.1%
384	1	< 0.1%
390	2	< 0.1%
410	1	< 0.1%
420	2	< 0.1%
430	1	< 0.1%
440	1	< 0.1%
460	1	< 0.1%

Value	Count	Frequency (%)
13540	1	< 0.1%
12050	1	< 0.1%
10040	1	< 0.1%
9890	1	< 0.1%
9640	1	< 0.1%
9200	1	< 0.1%
8670	1	< 0.1%
8020	1	< 0.1%
8010	1	< 0.1%
8000	1	< 0.1%

sqft_lot
Real number (ℝ)

Distinct	9782
Distinct (%)	45.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15106.968

Minimum	520
Maximum	1651359
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	169.0 KiB

Quantile statistics

Minimum	520
5-th percentile	1800
Q1	5040
median	7618
Q3	10688
95-th percentile	43339.2
Maximum	1651359
Range	1650839
Interquartile range (IQR)	5648

Descriptive statistics

Standard deviation	41420.512
Coefficient of variation (CV)	2.7418151
Kurtosis	285.07782
Mean	15106.968
Median Absolute Deviation (MAD)	2618
Skewness	13.060019
Sum	3.2650689 × 10⁸
Variance	1.7156588 × 10⁹
Monotonicity	Increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5000	358	1.7%
6000	290	1.3%
4000	251	1.2%
7200	220	1.0%
4800	120	0.6%
7500	119	0.6%
4500	114	0.5%
8400	111	0.5%
9600	109	0.5%
3600	103	0.5%
Other values (9772)	19818	91.7%

Value	Count	Frequency (%)
520	1	< 0.1%
572	1	< 0.1%
600	1	< 0.1%
609	1	< 0.1%
635	1	< 0.1%
638	1	< 0.1%
649	2	< 0.1%
651	1	< 0.1%
675	1	< 0.1%
676	1	< 0.1%

Value	Count	Frequency (%)
1651359	1	< 0.1%
1164794	1	< 0.1%
1074218	1	< 0.1%
1024068	1	< 0.1%
982998	1	< 0.1%
982278	1	< 0.1%
920423	1	< 0.1%
881654	1	< 0.1%
871200	2	< 0.1%
843309	1	< 0.1%

sqft_basement
Real number (ℝ)

Zeros

Distinct	306
Distinct (%)	1.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	291.50905

Minimum	0
Maximum	4820
Zeros	13126
Zeros (%)	60.7%
Negative	0
Negative (%)	0.0%
Memory size	169.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	560
95-th percentile	1190
Maximum	4820
Range	4820
Interquartile range (IQR)	560

Descriptive statistics

Standard deviation	442.57504
Coefficient of variation (CV)	1.5182206
Kurtosis	2.7155742
Mean	291.50905
Median Absolute Deviation (MAD)	0
Skewness	1.5779651
Sum	6300385
Variance	195872.67
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	13126	60.7%
600	221	1.0%
700	218	1.0%
500	214	1.0%
800	206	1.0%
400	184	0.9%
1000	149	0.7%
900	144	0.7%
300	142	0.7%
200	108	0.5%
Other values (296)	6901	31.9%

Value	Count	Frequency (%)
0	13126	60.7%
10	2	< 0.1%
20	1	< 0.1%
40	4	< 0.1%
50	11	0.1%
60	10	< 0.1%
65	1	< 0.1%
70	7	< 0.1%
80	20	0.1%
90	21	0.1%

Value	Count	Frequency (%)
4820	1	< 0.1%
4130	1	< 0.1%
3500	1	< 0.1%
3480	1	< 0.1%
3260	1	< 0.1%
3000	1	< 0.1%
2850	1	< 0.1%
2810	1	< 0.1%
2730	1	< 0.1%
2720	1	< 0.1%

yr_built
Real number (ℝ)

High correlation

Distinct	116
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1971.0051

Minimum	1900
Maximum	2015
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	169.0 KiB

Quantile statistics

Minimum	1900
5-th percentile	1915
Q1	1951
median	1975
Q3	1997
95-th percentile	2011
Maximum	2015
Range	115
Interquartile range (IQR)	46

Descriptive statistics

Standard deviation	29.373411
Coefficient of variation (CV)	0.014902757
Kurtosis	-0.6574075
Mean	1971.0051
Median Absolute Deviation (MAD)	23
Skewness	-0.4698054
Sum	42599334
Variance	862.79726
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2014	559	2.6%
2006	454	2.1%
2005	450	2.1%
2004	433	2.0%
2003	422	2.0%
2007	417	1.9%
1977	417	1.9%
1978	387	1.8%
1968	381	1.8%
2008	367	1.7%
Other values (106)	17326	80.2%

Value	Count	Frequency (%)
1900	87	0.4%
1901	29	0.1%
1902	27	0.1%
1903	46	0.2%
1904	45	0.2%
1905	74	0.3%
1906	92	0.4%
1907	65	0.3%
1908	86	0.4%
1909	94	0.4%

Value	Count	Frequency (%)
2015	38	0.2%
2014	559	2.6%
2013	201	0.9%
2012	170	0.8%
2011	130	0.6%
2010	143	0.7%
2009	230	1.1%
2008	367	1.7%
2007	417	1.9%
2006	454	2.1%

condition
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	169.0 KiB

0.5	14031
0.75	5679
1.0	1701
0.25	172
0.0	30

Length

Max length	4
Median length	3
Mean length	3.2707167
Min length	3

Characters and Unicode

Total characters	70690
Distinct characters	6
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0.5
2nd row	0.5
3rd row	0.5
4th row	0.5
5th row	0.5

Common Values

Value	Count	Frequency (%)
0.5	14031	64.9%
0.75	5679	26.3%
1.0	1701	7.9%
0.25	172	0.8%
0.0	30	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0.5	14031	64.9%
0.75	5679	26.3%
1.0	1701	7.9%
0.25	172	0.8%
0.0	30	0.1%

Most occurring characters

Value	Count	Frequency (%)
0	21643	30.6%
.	21613	30.6%
5	19882	28.1%
7	5679	8.0%
1	1701	2.4%
2	172	0.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	70690	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	21643	30.6%
.	21613	30.6%
5	19882	28.1%
7	5679	8.0%
1	1701	2.4%
2	172	0.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	70690	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	21643	30.6%
.	21613	30.6%
5	19882	28.1%
7	5679	8.0%
1	1701	2.4%
2	172	0.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	70690	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	21643	30.6%
.	21613	30.6%
5	19882	28.1%
7	5679	8.0%
1	1701	2.4%
2	172	0.2%

grade
Real number (ℝ)

High correlation

Distinct	12
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.55473943

Minimum	0
Maximum	1
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	169.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0.41666667
Q1	0.5
median	0.5
Q3	0.58333333
95-th percentile	0.75
Maximum	1
Range	1
Interquartile range (IQR)	0.083333333

Descriptive statistics

Standard deviation	0.097954896
Coefficient of variation (CV)	0.17657821
Kurtosis	1.1909321
Mean	0.55473943
Median Absolute Deviation (MAD)	0.083333333
Skewness	0.7711032
Sum	11989.583
Variance	0.0095951617
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
0.5	8981	41.6%
0.583333333	6068	28.1%
0.666666667	2615	12.1%
0.416666667	2038	9.4%
0.75	1134	5.2%
0.833333333	399	1.8%
0.333333333	242	1.1%
0.916666667	90	0.4%
0.25	29	0.1%
1	13	0.1%
Other values (2)	4	< 0.1%

Value	Count	Frequency (%)
0	1	< 0.1%
0.166666667	3	< 0.1%
0.25	29	0.1%
0.333333333	242	1.1%
0.416666667	2038	9.4%
0.5	8981	41.6%
0.583333333	6068	28.1%
0.666666667	2615	12.1%
0.75	1134	5.2%
0.833333333	399	1.8%

Value	Count	Frequency (%)
1	13	0.1%
0.916666667	90	0.4%
0.833333333	399	1.8%
0.75	1134	5.2%
0.666666667	2615	12.1%
0.583333333	6068	28.1%
0.5	8981	41.6%
0.416666667	2038	9.4%
0.333333333	242	1.1%
0.25	29	0.1%

price
Real number (ℝ)

High correlation

Distinct	3625
Distinct (%)	16.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	540182.16

Minimum	75000
Maximum	7700000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	169.0 KiB

Quantile statistics

Minimum	75000
5-th percentile	210000
Q1	321950
median	450000
Q3	645000
95-th percentile	1160000
Maximum	7700000
Range	7625000
Interquartile range (IQR)	323050

Descriptive statistics

Standard deviation	367362.23
Coefficient of variation (CV)	0.68007102
Kurtosis	34.522444
Mean	540182.16
Median Absolute Deviation (MAD)	150000
Skewness	4.0217156
Sum	1.1674957 × 10¹⁰
Variance	1.3495501 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
350000	172	0.8%
450000	172	0.8%
550000	159	0.7%
500000	152	0.7%
425000	150	0.7%
325000	148	0.7%
400000	145	0.7%
375000	138	0.6%
300000	133	0.6%
525000	131	0.6%
Other values (3615)	20113	93.1%

Value	Count	Frequency (%)
75000	1	< 0.1%
78000	1	< 0.1%
80000	1	< 0.1%
81000	1	< 0.1%
82000	1	< 0.1%
82500	1	< 0.1%
83000	1	< 0.1%
84000	1	< 0.1%
85000	2	< 0.1%
86500	1	< 0.1%

Value	Count	Frequency (%)
7700000	1	< 0.1%
7060000	1	< 0.1%
6890000	1	< 0.1%
5570000	1	< 0.1%
5350000	1	< 0.1%
5300000	1	< 0.1%
5110000	1	< 0.1%
4670000	1	< 0.1%
4500000	1	< 0.1%
4490000	1	< 0.1%

	bedrooms	condition	date	floors	grade	price	sqft_basement	sqft_living	sqft_lot	yr_built
bedrooms	1.000	0.024	-0.017	0.228	0.381	0.345	0.230	0.647	0.217	0.180
condition	0.024	1.000	0.049	0.179	0.154	0.023	0.094	0.060	0.039	0.248
date	-0.017	0.049	1.000	-0.023	-0.041	-0.011	-0.014	-0.035	-0.013	-0.002
floors	0.228	0.179	-0.023	1.000	0.502	0.322	-0.272	0.401	-0.234	0.552
grade	0.381	0.154	-0.041	0.502	1.000	0.658	0.093	0.716	0.152	0.501
price	0.345	0.023	-0.011	0.322	0.658	1.000	0.252	0.644	0.075	0.102
sqft_basement	0.230	0.094	-0.014	-0.272	0.093	0.252	1.000	0.328	0.037	-0.178
sqft_living	0.647	0.060	-0.035	0.401	0.716	0.644	0.328	1.000	0.304	0.352
sqft_lot	0.217	0.039	-0.013	-0.234	0.152	0.075	0.037	0.304	1.000	-0.038
yr_built	0.180	0.248	-0.002	0.552	0.501	0.102	-0.178	0.352	-0.038	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

	date	floors	bedrooms	sqft_living	sqft_lot	sqft_basement	yr_built	condition	grade	price
0	141022	1.5	4	2420	520	0	1900	0.5	0.500000	700000.0
1	150107	2.0	3	1050	572	310	2006	0.5	0.500000	250000.0
2	150122	2.0	2	1030	600	350	2004	0.5	0.583333	367500.0
3	150422	3.0	2	2470	609	560	2011	0.5	0.833333	1230000.0
4	141215	2.0	2	1070	635	350	2008	0.5	0.666667	256950.0
5	140627	3.0	1	1100	638	0	2014	0.5	0.666667	516500.0
6	150319	2.0	2	1070	649	350	2008	0.5	0.666667	259950.0
7	150305	2.0	2	1070	649	350	2008	0.5	0.666667	259950.0
8	150303	3.0	3	1060	651	0	2007	0.5	0.500000	405000.0
9	150407	2.0	1	1070	675	190	2007	0.5	0.583333	420000.0

	date	floors	bedrooms	sqft_living	sqft_lot	sqft_basement	yr_built	condition	grade	price
21603	150107	2.0	4	5545	871200	1940	2003	0.50	0.833333	937500.0
21604	150415	2.0	4	6530	871200	0	2008	0.50	0.833333	1600000.0
21605	150105	3.0	4	3920	881654	0	2002	0.50	0.833333	1650000.0
21606	150320	2.0	2	3900	920423	0	2009	0.50	0.916667	2000000.0
21607	140730	1.0	2	2560	982278	0	2004	0.50	0.583333	790000.0
21608	140905	2.0	4	3770	982998	0	1992	0.50	0.750000	998000.0
21609	150119	2.0	4	4030	1024068	0	2006	0.50	0.750000	855000.0
21610	140521	1.5	5	3010	1074218	1000	1931	1.00	0.583333	542500.0
21611	150504	1.0	2	710	1164794	0	1915	0.25	0.333333	190000.0
21612	150327	1.0	4	1300	1651359	0	1920	0.75	0.416667	700000.0

Overview

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Interactions

Correlations

Missing values

Sample

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Interactions

Correlations

Missing values

Sample